{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Correspondence, File & Rec Mgmt","CPPA","Mil Leave","Fitreps & Evals","Directives","ITEMPO","Awards","Recall & Mustering","Mil Manning ","RC Support"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Correspondence, File & Rec Mgmt","index":0,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,1,1],[12,0,12,1]]}
[null,null,"PART A - ADMINISTRATION"]
["ITEM #",null,"SECTION 1.  Correspondence","Yes","No","N/A"]
[null,null,"Ref:  (a) SECNAVINST M-5216.5\n                                                                                                                                             "]
[null,1,"Is outgoing correspondence prepared per the Navy Correspondence Manual?"]
[null,{"$f":"+B4+1","v":2},"Does command have a serial file?"]
[null,{"$f":"+B5+1","v":3},"Is outgoing correspondence being controlled/monitored?"]
[null,4,"Is action correspondence tracked and submitted timely?  Given a due date to comply with action date and controlled/monitored in order to respond in a timely manner?"]
[null,{"$f":"+B7+1","v":5},"Are general administration files maintained per Standard Subject Identification Code Instruction?"]
[null,{"$f":"+B8+1","v":6},"Are Command Correspondence files retained for two years? "]
[null,{"$f":"+B9+1","v":7},"Are financial \"By direction\" letters signed correctly?"]
[]
[]
["ITEM #",null,"SECTION 2. Tasks and Functions","Yes","No","N/A"]
[null,null,"Ref:  (a) OPNAVINST 3120.32D CH-1\nRef:  (b) OPNAVINST 1740.3D  \nRef:  (c) MILPERSMAN                                                                                                              "]
[null,{"$f":"+B14+1","v":1},"Is the Plan of the Day/Week/Month published per reference?"]
[null,2,"Are \"By direction\" personnel identified on the command's 5420 Notice or Letter of Designation?"]
[null,3,"Does command have a published organization chart? (provide copy)"]
[null,4,"Are \"Welcome Aboard\" packages sent to newly reporting members? "]
[null,5,"Does command send out a Naval Message to newly reporting active duty members?"]
[null,6,"Does command employ an effective Sponsor Program per reference?"]
[null,7,"Is there a formal check-in procedure for newly reporting personnel?"]
[null,8,"Is POM an effective medium for disseminating information to all members?",null,null,null,null,{"$f":"COUNTA(B17:B22)*1","v":6},{"$f":"COUNTA(F17:F22)*1","v":0},{"$f":"+H22-I22","v":6},{"$f":"COUNTA(D17:D22)*1","v":0},{"$f":"+K22/J22","v":0}]

{"sheet":"CPPA","index":1,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["ITEM #",null,"SECTION 3.  CPPA Duties","Yes","No","N/A"]
[null,null,"Ref:  (a) CPPA Handbook                                                                                                                                                                       Ref:  (b) MILPERSMAN 1000-21\nRef:  (c) SOPs (MyNavyHR Site) "]
[null,1,"Has a Command Pay and Personnel Administrator (CPPA) been designated in writing and have TOPS access?  "]
[null,2,"Is an effective feedback system established to ensure that required action submitted to PSD has been completed?  "]
[null,3,"Does each CPPA hold the required NEC IAW PPIB 17-10 (A16A; formerly 95AD)?"]
[null,4,"Do all PSD transactions flow through the command CPC?",null,null,null,null,{"$f":"COUNTA(B3:B6)*1","v":4},{"$f":"COUNTA(F3:F6)*1","v":0},{"$f":"+H6-I6","v":4},{"$f":"COUNTA(D3:D6)*1","v":0},{"$f":"+K6/J6","v":0}]
[null,5,"Are special screenings recertified 5 days prior to transfer?",null,null,null,null,{"$f":"COUNTA(B4:B7)*1","v":4},{"$f":"COUNTA(F4:F7)*1","v":0},{"$f":"+H7-I7","v":4},{"$f":"COUNTA(D4:D7)*1","v":0},{"$f":"+K7/J7","v":0}]
[null,6,"Are overseas screenings monitored in BOL?",null,null,null,null,{"$f":"COUNTA(B5:B8)*1","v":4},{"$f":"COUNTA(F5:F8)*1","v":0},{"$f":"+H8-I8","v":4},{"$f":"COUNTA(D5:D8)*1","v":0},{"$f":"+K8/J8","v":0}]

{"sheet":"Mil Leave","index":2,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["ITEM #",null,"SECTION 4. Military Leave","Yes","No","N/A"]
[null,null,"Ref:  (a) SECNAVINST 5216.5(series)\nRef:  (b) OPNAVINST 3120.32(series)     \nRef:  (c) MILPERSMAN 1050 (series)                                                                                                                      "]
[null,1,"Does the command have a leave policy signed by the CO?"]
[null,2,"Does command leave policy define \"immediate geographic area of duty station\"?"]
[null,3,"Does command leave policy define \"check out and in (on/off) leave\"?"]
[null,{"$f":"+B5+1","v":4},"Is monthly leave listing verified each month?"]

{"sheet":"Fitreps & Evals","index":3,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["ITEM #",null,"SECTION 5.  EVALS & FITREPS","Yes","No","N/A"]
[null,null,"Ref:  (a) BUPERSINST 1610.10E"]
[null,1,"Are Fitness Reports submitted in the correct format/timely manner per reference?"]
[null,{"$f":"+B3+1","v":2},"Are EVALS/FITREPS submitted in the correct format/timely manner per reference?"]
[null,3,"How are rejection letters handled and disseminated?"]
[null,4,"Are copies of all EVAL/FITREPS on file for the Reporting Senior (5 years)?"]
[null,5,"Have all members received a mid-term counseling?"]
[null,6,"Are copies of summary sheets on file for all EVAL/FITREPS?"]
[null,7,"Does Block #20 (physical readiness) for FITREPS/EVALS indicate status of the last PRT results and do they match PRIMS?  (Verify minimum of 30% of each pay grade)"]
[null,8,"Do E-5 and E-6 personnel have Post Summary Group Averages (PSGA) annotated in Block #43?"]
[null,9,"Is there a tracking system in place to ensure Departments know when Mid-Term Counseling/FITREPS/EVALS are due? (i.e.., Recurring Reports Notice etc.)",null,null,null,null,{"$f":"COUNTA(B3:B11)*1","v":9},{"$f":"COUNTA(F3:F11)*1","v":0},{"$f":"+H11-I11","v":9},{"$f":"COUNTA(D3:D11)*1","v":0},{"$f":"+K11/J11","v":0}]

{"sheet":"Directives","index":4,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["ITEM #",null,"SECTION 6.  Directives Management","Yes","No","N/A"]
[null,null,"Ref:  (a) OPNAV M-5215.1\nRef:  (b) OPNAVINST 5215.17A                                                                                                                                                                   "]
[null,1,"Are command directives being reviewed prior to publication to ensure compliance with references?"]
[null,{"$f":"+B3+1","v":2},"Is the unit's 5215 Notice kept current, reflection changes, revisions and deletions to the command's directives?  It is less than 12 months old?   "]
[null,3,"Is there an annual review system being utilized; OPNAV 5215/40?"]
[null,4,"Are cancelled directives identifed IAW reference (a), pages 1-5 and/or 1-6?"]
[null,5,"Is there a current 5216 distribution notice and is it current within the past 12 months?"]
[null,6,"Are case files properly maintained per references?"]
[null,7,"Is there a directives website, sharepoint, sharefolder, etc., that personnel can access?",null,null,null,null,{"$f":"COUNTA(B3:B9)*1","v":7},{"$f":"COUNTA(F3:F9)*1","v":0},{"$f":"+H9-I9","v":7},{"$f":"COUNTA(D3:D9)*1","v":0},{"$f":"+K9/J9","v":0}]
[null,8,"Does your organization have a current Standard Organization and Regulations Manual (SORM)?"]
[null,9,"Is there a current 5420 Collateral Duties notice and is it current within the past 6 months?"]

{"sheet":"ITEMPO","index":5,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["ITEM #",null,"SECTION 7.  ITEMPO","Yes","No","N/A"]
[null,1,"Does unit have all required current references for this section?"]
[null,{"$f":"+B2+1","v":2},"Does the unit have access to ITEMPO Reporting on BUPERS Online?"]
[null,{"$f":"+B3+1","v":3},"Are all AT's, ADT's, ADSW, Mobilizations, PRC's entered into ITEMPO?"," "]
[null,{"$f":"+B4+1","v":4},"Are all start and stop transactions verified?"]
[null,{"$f":"+B5+1","v":5},"Are reports reviewed monthly for errors or omissions?",null,null,null,null,{"$f":"COUNTA(B2:B6)*1","v":5},{"$f":"COUNTA(F2:F6)*1","v":0},{"$f":"+H6-I6","v":5},{"$f":"COUNTA(D2:D6)*1","v":1},{"$f":"+K6/J6","v":0.2}]

{"sheet":"Awards","index":6,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["ITEM #",null,"SECTION 8. Awards and Decorations","Yes","No","N/A"]
[null,null,"Ref:  (a) SECNAV M-1650.1\nRef:  (b) NSTCINST 1650.2D"]
[null,1,"Does the unit have an awards instruction and awards board?  "]
[null,{"$f":"+B3+1","v":2},"Is the current Personal Award Recommendation, OPNAV 1650/3 v3 form being used?"]
[null,{"$f":"+B4+1","v":3},"Is OPNAV 1650/3 form properly filled out?"]
[null,4,"Are previous personal decorations and period recognized copied from NDAWS to the form?"]
[null,5,"Are all required signature and date blocks signed and dated?"]
[null,6,"Do Award reps have access to BOL - NDAWS?"]
[null,7,"Is an adequate control system in use within the command for processing of awards and tracking awards recommended to higher authority?"]
[null,8,"Is there an awards tracker to prevent delays in submissions?"]
[null,9,"What is the command policy if an award is submitted late for processing?"]
[null,10,"Are previous personal decorations and period recognized verified via NDAWS?  "]
[null,11,"Do the citations meet proper format requirements IAW reference(a)?"]
[null,12,"Is the service for all Navy personnel “UNITED STATES NAVY” on the certificate/citation?"]
[null,13,"Does the date in “Date Approved” block match the date on the certificate/citation?"]
[null,14,"Is the award that’s been considered but not recommended for approval being forwarded via the remaining chain of command to the appropriate awarding authority?"]
[null,15,"Are copies of mid-tour awards forwarded with the recommendation?"]
[null,16,"Is there a system in place to ensure that approved awards are entered into NDAWS?  Verify all approved awards in NDAWS for the past 12 months.  Requires a 100% match unless the approved award was signed within the past 30 days. "]
[null,17,"Marine Corps Personnel - Is a copy of the approved OPNAV 1650/3, including the SOA, and signed award citation that’s awarded to Marine Corps personnel assigned to a Navy command forwarded to the CMC (MMMA) for recording and entry into the Marine’s official military record?"]
[null,18,"Does the command have a permanent record of all awards processed, including OPNAV 1650/3, a signed copy of the citation, supporting documents, and related correspondence?",null,null,null,null,{"$f":"COUNTA(B3:B20)*1","v":18},{"$f":"COUNTA(F3:F20)*1","v":0},{"$f":"+H20-I20","v":18},{"$f":"COUNTA(D3:D20)*1","v":0},{"$f":"+K20/J20","v":0}]
[]
[]
[null,null,"Submission timeline for FLOCs?"]
[null,null,"-Block 6:  DoD ID vice SSN"]
[null,null,"-Block 14:  Primary warfare device only"]
[null,null,"-Block 19:  Correct date format in chronological order"]
[null,null,"-Block 30:  Digital signature (submitting via BOL)"]
[null,null,"-Block 32:  Signature line - MILTON J. SANDS III, RDML, USN, COMMANDER"]
[null,null,"-Citations:  Opening and closing statements "]

{"sheet":"Recall & Mustering","index":7,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["ITEM #",null,"SECTION 1.  Correspondence","Yes","No","N/A"]
[null,null,"Ref:  (a) U.S. Navy Regulations, Chapter 8\nRef:  (b) Uniform Code of Military Justice, Article 86   \nRef:  (c) MILPERSMAN 1050-010                                                                                                                                                     \nRef:  (e) MILPERSMAN 1050-280"]
[null,1,"Is there written policy and procedures for mustering military personnel?"]
[null,2,"Are daily musters being taken in accordance with their stipulated policy?"]
[null,3,"Are any anomolies (e.g. Unauthorized Absences) being brought to the attention of the proper authority?"]
[null,4,"Are all personnel being accounted for in NFAAS as directed?"]

{"sheet":"Mil Manning ","index":8,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,1],[11,2,12,2]]}
["ITEM #",null,"Military Manning ","Yes","No","N/A"]
[null,null,"Ref:  (a) COMFLTFORCOM/COMNAVPERSCOMINST 1300.1A\nRef:  (b) BUPERSINST 1080.54 Enlisted Distribution and Verification Process"]
[null,1,"Does the command have an Activity Manning Manager?","X"]
[null,2,"Does the Activity Manning Manager have a designation letter?","X"]
[null,3,"Does the Activity Manning Manager have access to CMS-ID?","X"]
[null,4,"Does the Activity Manning Manager have the appropriate level of BBD access?","X"]
[null,5,"Does the Activity Manning Manager monitor Propsective Loss/Gains and Tentative Gains?","X"]
[null,6,"Are all military billets assigned to appropriate billet sequencing codes(BSC)?","X"]
[null,7,"Does AMM have Placement Coordinator contact information?","X"]
[null,8,"Does AMM have BSO/TYCOM contact information?","X"]
[null,null,"ADSW"]
[null,null,"Ref:  (a) OPNAVINST 1001.20C  (b) SPAWARINST 1100.1B"]
[]
[null,1,"Does the command have an ADSW coordinator?","X"]
[null,2,"Is the ADSW coordinator designated in writing?","X"]
[null,3,"Does the ADSW coordinator have a tracker of all ADSW personnel?","X"]
[null,4,"Does all ADSW personnel have a statement of understanding on file?","X"]
[null,5,"Are Requirement Information Sheet (RIS) on file?","X"]
[null,6,"Are By Name Request (BNR) on file?","X"]
[null,7,"Are all ADSW requirement submitted on time per the instruction?","X"]

{"sheet":"RC Support","index":9,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["ITEM #",null,"Reserve Support","Yes","No","N/A"]
[null,null,"Ref:  (a) SPAWARINST \n"]
[null,1,"Is support being provided to the local drilling unit(s) iaw reference (a)?","X",null,null,"(Yes.  As reserve personnel arrive for AT, command prepares TOPS events to ensure pay & entitlements are started)"]